Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.
Required skills
analytical skills to determine data objects required, data structures and business requirements
communication skills to liaise with clients to discuss issues
literacy skills to generate database and sample reports
technical skills to:
build a database using a commercially available database product, including Microsoft Structured Query Language (MS SQL) Server 7.0, Oracle and Sybase
register a data source name (DSN)
use appropriate database data formats
use appropriate RFID data formats
use data conversion programs
use hypertext markup language (HTML) or eXtensible markup language (XML)
use ISO/IEC standard 15962:2004 as a reference
use website administration software and site server utilities.
Required knowledge
client database data structures
client data management and data security policy and procedures
data analysis, particularly in determining data types and data structures and query and report design
data source names in use by the organisation
open database connection (ODC)
primary files and transaction logs to confirm appropriate database activity
quality assurance practices
software tools
system data requirements
system’s current functionality
website foundations.
The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.
Database may include: | commercial off-the-shelf (COTS) database packages object-relational databases proprietary databases relational databases software: Access connected to a structured query language (SQL) server DB2 Informix Ingres Microsoft SQL (MS SQL) server Mini SQL (mSQL) MySQL Oracle Sybase. |
Conversion programs may be in: | object-oriented language procedural programming language. |
Conversion tools may include: | analysis of data quality: QDB or Analyze WizRule Unitech Systems Inc cleansing data: Integrity Enterprise or Integrator data-mart management extraction and transformation: Evolutionary Technologies International (ETI) extract InfoPump, InfoHub, InfoRefiner and InfoSuite Passport Warehouse Manager. |
Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.
Observation Checklist